package hsintiao.com.xintiaoAPP.mapper;


import hsintiao.com.xintiaoAPP.entity.PayBill;
import hsintiao.com.xintiaoAPP.entity.alipaybill.DuplicateOrders;
import org.apache.ibatis.annotations.Param;

import java.util.Date;
import java.util.List;
import java.util.Set;

public interface PayBillMapper {
    void insert(PayBill payBill);

    //根据时间范围查询指定日期的订单总金额
    Long getTotalAmountByDate(@Param(value = "start") Date start, @Param(value = "end") Date end);

    //查询指定时间段是否有重复订单
    List<DuplicateOrders> checkDuplicateOrders(@Param(value = "start") Date start1, @Param(value = "end") Date end1);

    List<PayBill> selecByOuttradeno(String out_trade_no);

    void deleteByID(Long id);

    void deleteByDuplicateOuttradeno(String out_trade_no);

    List<PayBill> selectByDate(@Param(value = "start") Date start1, @Param(value = "end") Date start);

    void deleteByOuttradeno(String out_trade_no);

    List<PayBill> selectBatch(@Param(value = "my") Set<String> my);
}
